Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

Subquery
1) A correlated subquery
2) A correlated subquery references one or more columns in the outer query
3) All locations, where courses are offering, have no departments (subquery)
4) ALL with a Multiple Row Subquery
5) An example of a nested three-level subquery
6) ANY
7) ANY with a Multiple Row Subquery
8) Born after employee 4 was born
9) Compare with data from subquery
10) Compare with the sub query result
11) Correlated subquery using the EXISTS operator
12) Delete and subquery
13) EXISTS typically offers better performance than IN with subqueries
14) Exists in subquery
15) First three rows from subquery
16) Format result from subquery
17) Get Categories and Products (with Correlated Subqueries)
18) Greater than all subquery
19) Greater than any subquery
20) Greater than average salary
21) Greater than max(salary)
22) How Many Products By Department with correlated subqueries 2
23) If an inner query returns a NULL, the outer query also returns NULL
24) In and subquery
25) In subquery
26) Inline view
27) Inner query Demo
28) Larger than value from subquery
29) Multiple Row Subqueries
30) Multiple-row subqueries return more than one row of result from the subquery
31) Not equals and subquery
32) Not exists and subquery
33) Not exists subquery
34) Not in and subquery
35) NVL() is used to convert null in correlated query
36) Select from virtual table (sub query) with rownum
37) Selecting Products That Belong to Department with Subquery
38) Simple Subqueries in select statement
39) Single Row Subqueries May Return a Maximum of One Row
40) Single-row subqueries return only one row of result
41) Sub query
42) Sub query with table join
43) Subqueries in a FROM Clause (Inline Views)
44) Subqueries in a HAVING Clause
45) Subqueries in the SELECT column list (New Way)
46) Subqueries in the SELECT column list (Old way)
47) Subqueries in the WHERE Clause
48) Subqueries May Not Contain an ORDER BY Clause
49) Subqueries That Return Multiple Results
50) Subquery in from clause
51) Subquery in select statement
52) Subquery in update statement
53) Subquery in where clause
54) Subquery just returns a literal value
55) The parent query of a single-row subquery can return more than one row
56) To delete the records of emps whose salary is below the average salary in the department (correlated subquery)
57) To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery)
58) Use aggregate function in sub query
59) Use sub query as a virtual table
60) Using EXISTS with a Correlated Subquery
61) Using NOT EXISTS with a Correlated Subquery
62) Using Set Membership with Subqueries
63) Using subquery in the SET clause of UPDATE statement
64) Using the ALL Operator with subquery
65) Using the ANY Operator with subquery
66) Using the EXISTS and NOT EXISTS operators
67) Using the EXISTS Operator with subquery
68) When a query is ALL, each row in the result set is greater than the highest value returned
69) Working with multi-column subqueries
70) Writing Multiple Column Subqueries with table join
71) Writing Nested Subqueries
72) Writing Single Row Subqueries